package com.simple.elpmobile.onlinecase.db;

public class DBString {
	protected static class Tables {
		protected static interface DownloadTable {
			String TABLE_NAME = "downloadTable";

			String SQL_CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + " ("
					+ Columns.Download.M_ID
					+ " INTEGER PRIMARY KEY autoincrement, "
					+ Columns.Download.M_RESID + " TEXT, "
					+ Columns.Download.M_PAPERID + " VARCHAR(50), "
					+ Columns.Download.M_RESNAME + " TEXT, "
					+ Columns.Download.M_RESTYPE + " INTEGER, "
					+ Columns.Download.M_AREA + " TEXT, "
					+ Columns.Download.M_GRADE + " TEXT, "
					+ Columns.Download.M_PRESS + " TEXT, "
					+ Columns.Download.M_VERSION + " TEXT, "
					+ Columns.Download.M_ADDNAME + " TEXT, "
					+ Columns.Download.M_MTIME + " TEXT, "
					+ Columns.Download.M_SIZE + " TEXT, "
					+ Columns.Download.M_RES_DETAIL + " MEDIUMTEXT);";

			String SQL_DROP_TABLE = "DROP TABLE " + TABLE_NAME + ";";

			String[] COLUMNS = { Columns.Download.M_ID,
					Columns.Download.M_RESID, Columns.Download.M_PAPERID,
					Columns.Download.M_RESNAME, Columns.Download.M_RESTYPE,
					Columns.Download.M_AREA, Columns.Download.M_GRADE,
					Columns.Download.M_PRESS, Columns.Download.M_VERSION,
					Columns.Download.M_ADDNAME, Columns.Download.M_MTIME,
					Columns.Download.M_SIZE, Columns.Download.M_RES_DETAIL };
		}
	}

	protected static class Columns {
		protected static interface Download {

			String M_ID = "id";

			String M_RESID = "resId"; // 资源ID。

			String M_PAPERID = "paperId";

			String M_RESNAME = "resName";

			String M_RESTYPE = "resType";

			String M_AREA = "resArea";

			String M_GRADE = "resGrade";

			String M_PRESS = "resPress";

			String M_VERSION = "resIssue";

			String M_ADDNAME = "addName";

			String M_MTIME = "modifyTime";

			String M_SIZE = "resSize";

			String M_RES_DETAIL = "resDetails";

		}
	}
}